Excel 2011 Corrupt Files from .xlsm

Question

Level 1

8 points

Excel 2011 Corrupt Files from .xlsm

I've been dealing with this issue for several months. I receive an .xlsm file from a remote coworker, who is Windows based. Opens perfectly the first time after receiving. Then I work on the file, save and close. Go to reopen and the file is corrupted. Try to open and repair to no avail. I have done the open with Numbers and export back to Excel fix, but I lose my VBA and the formatting gets all screwy and it takes me hours to recover the work I did anyway. Any ideas?

iMac with Retina 5K display, OS X El Capitan (10.11.6)

Posted on Sep 15, 2016 4:21 AM

Reply

Answer 1

Sep 15, 2016 5:53 AM in response to itscraigdude

Numbers does NOT modify excel files. It imports them (converts them to Numbers) then allows you save in a native Numbers format or export back to excel. Either way you are always going through the excel -> Number translation and information can be altered.

If you really must use excel files for your livelihood I suggest you get excel installed so you can work more directly.

Reply

Answer 2

itscraigdude Author

Level 1

8 points

Sep 17, 2016 2:25 PM in response to Wayne Contello

I guess we can agree to disagree. Wayne, do you have any suggestions on how to get Excel installed properly so I can work more directly? I haven't heard of this problem before.

Reply